﻿CREATE FULLTEXT INDEX ON [dbo].[ToolURL]
    ([URL] LANGUAGE 1033, [URLNote] LANGUAGE 1033)
    KEY INDEX [PK_ToolURL]
    ON [Toolbox];


GO
CREATE FULLTEXT INDEX ON [dbo].[ToolTag]
    ([Tag] LANGUAGE 1033)
    KEY INDEX [PK4]
    ON [Toolbox];


GO
CREATE FULLTEXT INDEX ON [dbo].[ToolScript]
    ([Script] LANGUAGE 1033, [ScriptNote] LANGUAGE 1033)
    KEY INDEX [PK_ToolScript]
    ON [Toolbox];


GO
CREATE FULLTEXT INDEX ON [dbo].[ToolNote]
    ([Note] LANGUAGE 1033)
    KEY INDEX [PK2]
    ON [Toolbox];


GO
CREATE FULLTEXT INDEX ON [dbo].[Tool]
    ([Title] LANGUAGE 1033, [Description] LANGUAGE 1033)
    KEY INDEX [PK1]
    ON [Toolbox];


GO
CREATE FULLTEXT INDEX ON [dbo].[ToolFile]
    ([file_stream] TYPE COLUMN [file_type] LANGUAGE 1033, [name] LANGUAGE 1033)
    KEY INDEX [PK__ToolFile__5A5B77D580F02547]
    ON [Toolbox];

